package com.fulong.dao;

import com.fulong.entity.UserBaiseInfoEntity;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.fulong.entity.UserBaiseInfoEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.Map;

/**
 * 
 * 
 * @author fulong
 * @email ${email}
 * @date 2022-03-24 10:31:23
 */
@Mapper
public interface UserBaiseInfoDao extends BaseMapper<UserBaiseInfoEntity> {
	@Select("SELECT c.label from user_baise_info as a RIGHT  JOIN device_manage_approver as b ON a.id = b.approver RIGHT JOIN device_baise_info as c ON b.typeid= c.id WHERE a.id = #{id}")
    Map<String , Object> getApproverInfo(String id) ;
}
